<?Lassoscript
// Last modified 4/17/09 by Eric Landmann

// CHANGE NOTES
// 4/17/09
// Version 1.0

Include:'siteconfig.lasso';

Var:'vPage_Title'='Updated Member Confirmation';

Include:($svLibsPath)'page_header.inc';

// Start the Session
Include:($svLibsPath)'sessions.inc'; 
Include:($svLibsPath)'header2.inc'; 

// Debugging
// Var:'svDebug' = 'Y';

'<div align="center">\r';

// Performing Search from svPost_Name1 and svPass
Inline: -Update,
	-Database=$svSiteDatabase,
	-Table=$svMembersTable,
	-Username=$svSiteUsername,
	-Password=$svSitePassword,
	-KeyField='id',
	-KeyValue=(Var:'svMemberID'),
	'First_Name' = (Action_Param:'First_Name'),
	'Last_Name' = (Action_Param:'Last_Name'),
	'Post_Name1' = (Action_Param:'Post_Name1'),
	'Post_Name2' = (Action_Param:'Post_Name2'),
	'Post_Name3' = (Action_Param:'Post_Name3'),
	'Post_Name4' = (Action_Param:'Post_Name4'),
	'Post_Name5' = (Action_Param:'Post_Name5'),
	'Pass' = (Action_Param:'Pass'),
	'Mail' = (Action_Param:'Mail'),
	'Fav_Crag' = (Action_Param:'Fav_Crag'),
	'Address' = (Action_Param:'Address'),
	'City' = (Action_Param:'City'),
	'State' = (Action_Param:'State'),
	'Zip' = (Action_Param:'Zip'),
	'Country' = (Action_Param:'Country'),
	'Phone' = (Action_Param:'Phone'),
	'Fav_URL' = (Action_Param:'Fav_URL'),
	'Sex' = (Action_Param:'Sex'),
	'Year_Born' = (Action_Param:'Year_Born'),
	'Type' = (Action_Param:'Type'),
	'Ability' = (Action_Param:'Ability'),
	'Achieve' = (Action_Param:'Achieve'),
	'Statement' = (Action_Param:'Statement'),
	'Email_Forum1' = (Action_Param:'Email_Forum1'),
	'Email_Forum2' = (Action_Param:'Email_Forum2'),
	'Email_Forum3' = (Action_Param:'Email_Forum3'),
	'Email_Forum4' = (Action_Param:'Email_Forum4'),
	'Email_Forum5' = (Action_Param:'Email_Forum5'),
	'Email_Forum6' = (Action_Param:'Email_Forum6'),
	'Email_Forum7' = (Action_Param:'Email_Forum7'),
	'Email_Forum8' = (Action_Param:'Email_Forum8'),
	'Email_Forum9' = (Action_Param:'Email_Forum9'),
	'Email_Forum10' = (Action_Param:'Email_Forum10'),
	'Email_Forum11' = (Action_Param:'Email_Forum11'),
	'Email_Forum12' = (Action_Param:'Email_Forum12');

	// Debugging
	Debug;
		'<strong>61: Update Members ERROR:</strong> ' (Error_CurrentError) '<br><br>\n';
	/Debug;
	
/Inline;

// Get new Email Preference values
Inline: -Search,
	-Database=$svSiteDatabase,
	-Table=$svMembersTable,
	-Username=$svSiteUsername,
	-Password=$svSitePassword,
	-KeyField='id',
	-KeyValue=(Var:'svMemberID');

	Var:'svEmail_Forum1' = (Field:'Email_Forum1');
	Var:'svEmail_Forum2' = (Field:'Email_Forum2');
	Var:'svEmail_Forum3' = (Field:'Email_Forum3');
	Var:'svEmail_Forum4' = (Field:'Email_Forum4');
	Var:'svEmail_Forum5' = (Field:'Email_Forum5');
	Var:'svEmail_Forum6' = (Field:'Email_Forum6');
	Var:'svEmail_Forum7' = (Field:'Email_Forum7');
	Var:'svEmail_Forum8' = (Field:'Email_Forum8');
	Var:'svEmail_Forum9' = (Field:'Email_Forum9');
	Var:'svEmail_Forum10' = (Field:'Email_Forum10');
	Var:'svEmail_Forum11' = (Field:'Email_Forum11');
	Var:'svEmail_Forum12' = (Field:'Email_Forum12');
/Inline;

?>
<div align="center"><h2>Thank you for updating your member profile.</h2>

[Output_None]<!-- Making a table for the link -->[/Output_None]
<table border="0" cellspacing="1" cellpadding="4" width="50%">
      <tr> 
        <td bgcolor="[Var:'']"> 
          <p align="center"><strong><a href="m_update.lasso">View your updated Member Profile</a></strong></p>
		</td>
	</tr>
</table>

[Output_None]<!-- Forums Home link -->[/Output_None]
<table border="0" cellspacing="1" cellpadding="4" width="50%">
      <tr> 
        <td bgcolor="[Var:'']"> 
          <p align="center"><strong><a href="forums.lasso">Forums Home</a></strong></p>
		</td>
	</tr>
</table>
</div>
<?Lassoscript

Include:($svLibsPath)'footer.inc';
?>
</div>
</body>
</html>
